Simplicty and flexibility!


Function::Mathematical

Abs (absolute value)
abs(NUMERIC VALUE)
abs(-1232)
abs(0.323)
abs(MySumField*YourSumfield)


The abs function converts a numeric value to a positive, unsigned numeric value.

Parameters


Numeric Value i.e. any number between -n via 0 to +n

Returns/Result


Positive Numeric Value 0 to +n

Examples


Example 1


abs(-8)

Result: 8

Example 2


abs(8)

Result: 8

Example 3


Alternative DataEase derivation that will give same result:

if (Field<0,Field*-1,Field)

Reference

abs (absolute value)

Type

Math Function

Purpose

The abs function converts a numeric value to a positive, unsigned numeric value.

Syntax

abs( NUMERIC VALUE)

Returns

A numeric value.

Usage

The numeric value in a Math function can be a constant value (as shown below), a variable, a field value or an expression.

The abs function can only be used with a numeric value. A non-numeric value always returns a value of 0.

Examples

 abs( -453)

 Returns: 453

 

 abs( 4.53)

 Returns: 4.53

See Also


On the forum about Abs (absolute value)

On the blog about Abs (absolute value)


dg3_HelpView